/ PC Pro 2005 June (DVD) / DPPRO0605DVD.iso / Extras / TextPipe / textpipepro-cr.exe / {app} / report extraction / copy data down.fll

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 54 50 46 30 0b 54 46 69 | 6c 74 65 72 4c 69 73 74 |TPF0.TFi|lterList|
|00000010| 00 0a 46 69 6c 74 65 72 | 4c 69 73 74 01 08 54 56 |..Filter|List..TV|
|00000020| 65 72 73 69 6f 6e 00 07 | 56 65 72 73 69 6f 6e 02 |ersion..|Version.|
|00000030| 48 06 a7 0d 0a 54 68 69 | 73 20 69 73 20 61 20 54 |H....Thi|s is a T|
|00000040| 65 78 74 50 69 70 65 20 | 50 72 6f 20 66 69 6c 74 |extPipe |Pro filt|
|00000050| 65 72 20 66 69 6c 65 2c | 20 61 6e 20 61 70 70 6c |er file,| an appl|
|00000060| 69 63 61 74 69 6f 6e 20 | 66 6f 72 20 6d 61 6e 69 |ication |for mani|
|00000070| 70 75 6c 61 74 69 6e 67 | 20 61 6e 64 20 65 78 74 |pulating| and ext|
|00000080| 72 61 63 74 69 6e 67 20 | 74 65 78 74 20 66 69 6c |racting |text fil|
|00000090| 65 73 20 6f 66 20 61 6e | 79 20 73 69 7a 65 2e 20 |es of an|y size. |
|000000a0| 54 6f 20 66 69 6e 64 20 | 6f 75 74 20 6d 6f 72 65 |To find |out more|
|000000b0| 20 67 6f 20 74 6f 20 68 | 74 74 70 3a 2f 2f 77 77 | go to h|ttp://ww|
|000000c0| 77 2e 63 72 79 73 74 61 | 6c 73 6f 66 74 77 61 72 |w.crysta|lsoftwar|
|000000d0| 65 2e 63 6f 6d 2e 61 75 | 0d 0a 06 00 12 00 00 00 |e.com.au|........|
|000000e0| 00 12 3f 00 00 00 61 00 | 2c 00 62 00 2c 00 74 00 |..?...a.|,.b.,.t.|
|000000f0| 69 00 74 00 6c 00 65 00 | 31 00 2c 00 63 00 2c 00 |i.t.l.e.|1.,.c.,.|
|00000100| 64 00 0d 00 0a 00 2c 00 | 62 00 2c 00 2c 00 63 00 |d.....,.|b.,.,.c.|
|00000110| 2c 00 64 00 0d 00 0a 00 | 32 00 2c 00 62 00 2c 00 |,.d.....|2.,.b.,.|
|00000120| 74 00 69 00 74 00 6c 00 | 65 00 32 00 2c 00 63 00 |t.i.t.l.|e.2.,.c.|
|00000130| 2c 00 64 00 0d 00 0a 00 | 2c 00 62 00 2c 00 74 00 |,.d.....|,.b.,.t.|
|00000140| 69 00 74 00 6c 00 65 00 | 33 00 2c 00 63 00 2c 00 |i.t.l.e.|3.,.c.,.|
|00000150| 64 00 0d 00 0a 00 2c 00 | 62 00 2c 00 2c 00 63 00 |d.....,.|b.,.,.c.|
|00000160| 2c 00 64 00 01 06 03 7c | 41 41 00 08 06 0c 74 65 |,.d....||AA....te|
|00000170| 78 74 70 69 70 65 2e 6c | 6f 67 09 03 f4 01 00 00 |xtpipe.l|og......|
|00000180| 02 00 09 14 54 46 69 6c | 74 65 72 43 6f 6d 6d 65 |....TFil|terComme|
|00000190| 6e 74 4f 62 6a 65 63 74 | 00 07 65 6e 61 62 6c 65 |ntObject|..enable|
|000001a0| 64 09 0a 4c 69 73 74 4f | 62 6a 65 63 74 09 00 00 |d..ListO|bject...|
|000001b0| 02 01 08 0c 54 49 6e 70 | 75 74 4f 62 6a 65 63 74 |....TInp|utObject|
|000001c0| 00 07 65 6e 61 62 6c 65 | 64 09 0b 49 6e 70 75 74 |..enable|d..Input|
|000001d0| 4f 62 6a 65 63 74 09 08 | 02 00 02 01 02 64 08 08 |Object..|.....d..|
|000001e0| 03 00 04 00 00 02 01 08 | 0e 54 43 6f 6d 6d 65 6e |........|.TCommen|
|000001f0| 74 4f 62 6a 65 63 74 00 | 07 65 6e 61 62 6c 65 64 |tObject.|.enabled|
|00000200| 09 0d 43 6f 6d 6d 65 6e | 74 4f 62 6a 65 63 74 09 |..Commen|tObject.|
|00000210| 06 8e 54 68 69 73 20 65 | 78 61 6d 70 6c 65 20 73 |..This e|xample s|
|00000220| 68 6f 77 73 20 68 6f 77 | 20 74 6f 20 63 6f 70 79 |hows how| to copy|
|00000230| 20 64 61 74 61 20 64 6f | 77 6e 20 61 20 63 6f 6c | data do|wn a col|
|00000240| 75 6d 6e 2e 20 0d 0a 0d | 0a 55 73 65 20 61 20 52 |umn. ...|.Use a R|
|00000250| 65 73 74 72 69 63 74 69 | 6f 6e 20 28 43 53 56 20 |estricti|on (CSV |
|00000260| 66 69 65 6c 64 2c 20 54 | 61 62 20 66 69 65 6c 64 |field, T|ab field|
|00000270| 2c 20 43 6f 6c 75 6d 6e | 73 29 20 74 6f 20 63 6f |, Column|s) to co|
|00000280| 6e 74 72 6f 6c 20 77 68 | 69 63 68 20 64 61 74 61 |ntrol wh|ich data|
|00000290| 20 69 73 20 63 6f 70 69 | 65 64 20 64 6f 77 6e 2e | is copi|ed down.|
|000002a0| 00 00 02 01 09 14 54 44 | 65 6c 65 74 65 43 6f 6c |......TD|eleteCol|
|000002b0| 75 6d 6e 73 4f 62 6a 65 | 63 74 00 07 65 6e 61 62 |umnsObje|ct..enab|
|000002c0| 6c 65 64 09 13 44 65 6c | 65 74 65 43 6f 6c 75 6d |led..Del|eteColum|
|000002d0| 6e 73 4f 62 6a 65 63 74 | 09 02 01 02 03 02 01 02 |nsObject|........|
|000002e0| 04 02 01 09 09 09 00 00 | 02 02 08 0d 54 53 63 72 |........|....TScr|
|000002f0| 69 70 74 4f 62 6a 65 63 | 74 00 07 65 6e 61 62 6c |iptObjec|t..enabl|
|00000300| 65 64 09 0c 53 63 72 69 | 70 74 4f 62 6a 65 63 74 |ed..Scri|ptObject|
|00000310| 09 0c 4c 02 00 00 27 63 | 6f 70 79 20 76 61 6c 75 |..L...'c|opy valu|
|00000320| 65 73 20 64 6f 77 6e 20 | 61 20 63 6f 6c 75 6d 6e |es down |a column|
|00000330| 0d 0a 0d 0a 64 69 6d 20 | 6f 6c 64 76 61 6c 75 65 |....dim |oldvalue|
|00000340| 0d 0a 0d 0a 27 43 61 6c | 6c 65 64 20 66 6f 72 20 |....'Cal|led for |
|00000350| 65 76 65 72 79 20 6c 69 | 6e 65 20 69 6e 20 74 68 |every li|ne in th|
|00000360| 65 20 66 69 6c 65 0d 0a | 27 45 4f 4c 20 63 6f 6e |e file..|'EOL con|
|00000370| 74 61 69 6e 73 20 74 68 | 65 20 65 6e 64 20 6f 66 |tains th|e end of|
|00000380| 20 6c 69 6e 65 20 63 68 | 61 72 61 63 74 65 72 73 | line ch|aracters|
|00000390| 20 28 55 6e 69 78 2c 20 | 44 4f 53 20 6f 72 20 4d | (Unix, |DOS or M|
|000003a0| 61 63 29 20 74 68 61 74 | 20 6d 75 73 74 20 62 65 |ac) that| must be|
|000003b0| 0d 0a 27 61 70 70 65 6e | 64 65 64 20 74 6f 20 65 |..'appen|ded to e|
|000003c0| 61 63 68 20 6c 69 6e 65 | 0d 0a 66 75 6e 63 74 69 |ach line|..functi|
|000003d0| 6f 6e 20 70 72 6f 63 65 | 73 73 4c 69 6e 65 28 6c |on proce|ssLine(l|
|000003e0| 69 6e 65 2c 20 45 4f 4c | 29 0d 0a 0d 0a 20 20 69 |ine, EOL|)....  i|
|000003f0| 66 20 74 72 69 6d 28 6c | 69 6e 65 20 26 20 45 4f |f trim(l|ine & EO|
|00000400| 4c 29 20 3c 3e 20 22 22 | 20 74 68 65 6e 0d 0a 20 |L) <> ""| then.. |
|00000410| 20 20 20 6f 6c 64 76 61 | 6c 75 65 20 3d 20 6c 69 |   oldva|lue = li|
|00000420| 6e 65 20 26 20 45 4f 4c | 0d 0a 20 20 65 6e 64 20 |ne & EOL|..  end |
|00000430| 69 66 0d 0a 20 20 70 72 | 6f 63 65 73 73 4c 69 6e |if..  pr|ocessLin|
|00000440| 65 20 3d 20 22 22 0d 0a | 0d 0a 65 6e 64 20 66 75 |e = ""..|..end fu|
|00000450| 6e 63 74 69 6f 6e 0d 0a | 0d 0a 0d 0a 73 75 62 20 |nction..|....sub |
|00000460| 73 74 61 72 74 4a 6f 62 | 28 29 0d 0a 20 20 6f 6c |startJob|()..  ol|
|00000470| 64 76 61 6c 75 65 20 3d | 20 22 22 0d 0a 65 6e 64 |dvalue =| ""..end|
|00000480| 20 73 75 62 0d 0a 0d 0a | 0d 0a 73 75 62 20 65 6e | sub....|..sub en|
|00000490| 64 4a 6f 62 28 29 0d 0a | 65 6e 64 20 73 75 62 0d |dJob()..|end sub.|
|000004a0| 0a 0d 0a 0d 0a 66 75 6e | 63 74 69 6f 6e 20 73 74 |.....fun|ction st|
|000004b0| 61 72 74 46 69 6c 65 28 | 29 0d 0a 20 20 73 74 61 |artFile(|)..  sta|
|000004c0| 72 74 46 69 6c 65 20 3d | 20 22 22 0d 0a 65 6e 64 |rtFile =| ""..end|
|000004d0| 20 66 75 6e 63 74 69 6f | 6e 0d 0a 0d 0a 0d 0a 66 | functio|n......f|
|000004e0| 75 6e 63 74 69 6f 6e 20 | 65 6e 64 46 69 6c 65 28 |unction |endFile(|
|000004f0| 29 0d 0a 20 20 27 6f 75 | 74 70 75 74 20 74 68 65 |)..  'ou|tput the|
|00000500| 20 76 61 6c 75 65 20 69 | 66 20 74 68 65 72 65 20 | value i|f there |
|00000510| 69 73 20 6f 6e 65 2c 20 | 6f 72 20 74 68 65 20 6c |is one, |or the l|
|00000520| 61 73 74 20 76 61 6c 75 | 65 0d 0a 20 20 27 69 66 |ast valu|e..  'if|
|00000530| 20 69 74 20 69 73 20 62 | 6c 61 6e 6b 0d 0a 20 20 | it is b|lank..  |
|00000540| 65 6e 64 46 69 6c 65 20 | 3d 20 6f 6c 64 56 61 6c |endFile |= oldVal|
|00000550| 75 65 0d 0a 65 6e 64 20 | 66 75 6e 63 74 69 6f 6e |ue..end |function|
|00000560| 0d 0a 06 08 56 42 53 63 | 72 69 70 74 03 10 27 00 |....VBSc|ript..'.|
|00000570| 00 02 01 08 0d 54 4f 75 | 74 70 75 74 4f 62 6a 65 |.....TOu|tputObje|
|00000580| 63 74 00 07 65 6e 61 62 | 6c 65 64 09 0c 4f 75 74 |ct..enab|led..Out|
|00000590| 70 75 74 4f 62 6a 65 63 | 74 09 02 02 08 02 01 08 |putObjec|t.......|
|000005a0| 06 04 2e 74 78 74 08 06 | 03 43 3a 5c 09 06 14 63 |...txt..|.C:\...c|
|000005b0| 3a 5c 6d 65 72 67 65 66 | 69 6c 65 6e 61 6d 65 2e |:\mergef|ilename.|
|000005c0| 74 78 74 08 08 00 00 00 | 02 19 08 08 08 00 00    |txt.....|....... |
+--------+-------------------------+-------------------------+--------+--------+